package Table_Struct

//备件
type Sparepart struct {
	Sname string  //备件名称
	Smodel string //备件型号
	Sunivalence float64 //备件单价
	Snumber int //备件数量
	Salertquantity int //备件警戒数量
	Sinventorystatus string //库存状态
}

//CREATE TABLE public.sparepart
//(
//sname character(50) COLLATE pg_catalog."default" NOT NULL,
//smodel character(20) COLLATE pg_catalog."default",
//sinventorystatus character(20) COLLATE pg_catalog."default",
//snumber integer NOT NULL,
//salertquantity integer NOT NULL,
//sunivalence double precision NOT NULL,
//CONSTRAINT sparepart_pkey PRIMARY KEY (sname)
//)
//
//TABLESPACE pg_default;
//
//ALTER TABLE public.sparepart
//OWNER to postgres;